using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

using PConsulting.DataSets;

namespace PConsulting.DataAccess
{
    public class Utilities
    {
        private string connectionString;

        public Utilities()
        {
            connectionString = ConfigurationManager.ConnectionStrings["PConsultingDB"].ConnectionString;
        }

        public tdsStatus SelectStatus()
        {
            tdsStatus tds = new tdsStatus();
            DataSet ds = SqlHelper.GetDataSet(connectionString, "Status_Select");
            ds.Tables[0].TableName = "tblTimesheetStatus";
            tds.Merge(ds);
            return tds;
        }
    }
}
